/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package pio.action.administrador;

import DBMS.DataBaseManager;
import clases.Institucion;
import java.util.ArrayList;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;

/**
 *
 * @author charles
 */
public class ConsultarMencion extends org.apache.struts.action.Action {

  /* forward name="success" path="" */
  private static final String SUCCESS = "success";

  /**
   * This is the action called from the Struts framework.
   * @param mapping The ActionMapping used to select this instance.
   * @param form The optional ActionForm bean for this request.
   * @param request The HTTP Request we are processing.
   * @param response The HTTP Response we are processing.
   * @throws java.lang.Exception
   * @return
   */
  @Override
  public ActionForward execute(ActionMapping mapping, ActionForm form,
          HttpServletRequest request, HttpServletResponse response)
          throws Exception {
    Institucion mencion = new Institucion();
    mencion.setId(Integer.valueOf(request.getParameter("institucionid")));
    DataBaseManager dbms = DataBaseManager.getInstance();
    ArrayList menciones = dbms.consultarMencionesDiversificado(mencion);
    if (menciones.isEmpty()) {
      request.setAttribute("menciones", "No se han creado menciones para esta institucion");
    } else {
      String m = "<table>";
      for (int i = 0; i < menciones.size(); i++) {
        m += "<tr><td>" + menciones.get(i) + "</td></tr>";
      }
      m += "</table>";
      request.setAttribute("menciones", m);
    }
    request.setAttribute("institucionid", mencion.getId());    
    return mapping.findForward(SUCCESS);
  }
}
